package com.ruoyi.huanghefd.mapper;

import com.ruoyi.huanghefd.domain.Makesheet;
import org.apache.ibatis.annotations.Param;

import com.ruoyi.huanghefd.domain.WorksheetDh;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @Entity com.ruoyi.huanghefd.domain.WorksheetDh
 */
@Mapper
public interface WorksheetDhMapper extends BaseMapper<WorksheetDh> {

    /**
     * @param worksheetDh
     * @return int
     * @Author gnplum
     * @Description //新增动火票
     * @Date 15:50 2023/11/12
     **/
    int insertAll(WorksheetDh worksheetDh);

    /**
     * @param dhCode
     * @return int
     * @Author gnplum
     * @Description //删除动火票
     * @Date 15:54 2023/11/12
     **/
    int delByDhId(@Param("dhCode") String dhCode);

    /**
     * @param worksheetDh
     * @return int
     * @Author gnplum
     * @Description //修改动火票
     * @Date 15:55 2023/11/12
     **/
    int updatebyDsId(WorksheetDh worksheetDh);

    /**
     * @param dhCode
     * @param dhDept
     * @param dhState
     * @param userId
     * @param mailType
     * @return java.util.List<com.ruoyi.huanghefd.domain.WorksheetDh>
     * @Author gnplum
     * @Description //查询动火票  分页
     * @Date 15:55 2023/11/12
     **/
    List<WorksheetDh> queryWorksheetDhListByPage(@Param("dhCode") String dhCode, @Param("dhDept") String dhDept, @Param("dhState") String dhState, @Param("userId") String userId, @Param("mailType") String mailType, @Param("dhType") String dhType, @Param("startIndex") int startIndex, @Param("pageSize") int pageSize);

    List<WorksheetDh> queryWorksheetDhList(@Param("dhCode") String dhCode, @Param("dhDept") String dhDept, @Param("dhState") String dhState, @Param("userId") String userId, @Param("mailType") String mailType);

    /**
     * @return int
     * @Author gnplum
     * @Description //查询动火票 分页总数
     * @Date 2:02 2023/12/20
     **/
    int getWorksheetDhNum(@Param("dhCode") String dhCode, @Param("dhDept") String dhDept, @Param("dhState") String dhState, @Param("userId") String userId, @Param("mailType") String mailType, @Param("dhType") String dhType);

    /**
     * @Author gnplum
     * @Description //获取动火编号
     * @Date 16:34 2023/11/6
     * @return int
     **/
    int getWsDhCodeNum(@Param("PJLX") String PJLX);
}




